﻿CREATE TABLE [dbo].[AW_Contact] (
    [ContactId]       UNIQUEIDENTIFIER NOT NULL,
    [ProspectiveType] TINYINT          NOT NULL,
    [Name]            NVARCHAR (500)   NOT NULL,
    [NickName]        NVARCHAR (250)   NULL,
    [CompanyName]     NVARCHAR (250)   NULL,
    [Department]      NVARCHAR (250)   NULL,
    [JobTitle]        NVARCHAR (250)   NULL,
    [Remark]          NVARCHAR (MAX)   NULL,
    [Phone]           NVARCHAR (250)   NULL,
    [Mobile]          NVARCHAR (250)   NOT NULL,
    [Fax]             NVARCHAR (250)   NULL,
    [Email]           NVARCHAR (250)   NULL,
    [Address]         NVARCHAR (MAX)   NULL,
    [CreateDate]      DATETIME         NOT NULL,
    [StatusDelete]    TINYINT          NOT NULL,
    CONSTRAINT [PK_AW_Contact] PRIMARY KEY CLUSTERED ([ContactId] ASC)
);




GO


